Dump-N-Load Readme.txt 10/25/2006

Here are some Progress dump/load programs and UNIX scripts I find useful.

Files:
-----
 1. bulkdump.p          It creates binary dump/load and index rebuild scripts.
 2. bulkdump_com.p      It creates binary dump/load and index rebuild scripts.
 3. bulkdump_com_mult.p It creates binary dump/load and index rebuild scripts.
 4. bulkdump2.p         Subprogram for bulkdump.p
 5. bzip_dump.p         A Progress program which dumps all tables is a database.  It skips empty and _* tables.  Each tables is dumped to a separate file, same as the Progress dump utility, but each file is compressed.  It uses bzip as the compression engine.  These file can later be loaded into a database using bzip_load.p.  I wrote this because we are sometimes low on disk space, and don't have the money to get more.
 6. bzip_dump2.p        Subprogram for bzip_dump.p
 7. bzip_load.p         This is the companion program for bzip_dump.p.  It has a number of options which can help speed the load of data, and can mimic the bulk loader in Progress.  If you deactivate indexes you must rebuild them after loading data.
 8. bzip_load2.p        Subprogram for bzip_load.p
 9. dumpload.sh         A semi-automated dump/load script.
10. freeze.p            This will freeze all tables in a database.
11. gzip_dump.p         Same as bzip_dump.p, but it uses gzip as the compression engine.
12. gzip_dump2.p        Subprogram for gzip_dump.p
13. gzip_load.p         Same as bzip_laod.p, but it uses gzip as the compression engine.
14. gzip_load2.p        Subprogram for gzip_load.p
15. list_tables.p       This will output a list of all tables in a database.
16. list_non-empty_tables.p   This will output a list of all non-empty tables in a database.
17. my_dump.i           Include file for *_dump.p
18. my_dump2.i          Include file for *_dump2.p
19. my_load.i           Include file for *_load.p
20. my_load2.i          Include file for *_load2.p
21. unfreeze.p          This will unfreeze all tables in a database.
22. upd_main.p          I wrote to ease the pain of loading data, .d files, when upgrading Progress applications.  This version was used to upgrade to QAD MFG/Pro 9.0 SP4, TRW AIM 2.0h and TRW Rocca 3.0.  This utility gives you the ability to load .d files with new or changed data without error.  It will log any new, changed or deleted data compared with the target database into separate log files.  You can even generate log files without actually making updates to the database.  You can update this program for use with any table.  Parameters 3+ passed to upd_sub.p are the fields of a unique index that are used for comparison purposes.
23. upd_sub.p           Subprogram for upd_main.p

Notes:
-----
1. The *_dump.p and *_load.p programs are really meant for the times when you need to do a full dump/load of a database.
2. Scripts are meant to changed as needed.
3. Compression engines need to be in your path.
4. The level of compression can be changed by editing *_dump.p.
5. If you have a fast enough CPU the extra resources needed to do the compression are offset by the smaller amount of data that is written and read from disk.